Tabela LPatientMsgEventMsgChannel

Definicja tabeli LPatientMsgEventMsgChannel

Name

LPatientMsgEventMsgChannel

Code

LPatientMsgEventMsgChannel

Comment

 


Lista kolumn tabeli LPatientMsgEventMsgChannel

Name

Code

PatientMsgEventID

PatientMsgEventID

MsgChannelID

MsgChannelID

ScheduleExpression

ScheduleExpression

Synchronously

Synchronously

Active

Active

UserGroupIDs

UserGroupIDs

UserTypeIDs

UserTypeIDs

PersonIDs

PersonIDs

HeadOfWard

HeadOfWard

EventDoctor

EventDoctor

TwoWayEnabled

TwoWayEnabled


Kolumna PatientMsgEventID tabeli LPatientMsgEventMsgChannel

Definicja kolumny PatientMsgEventID tabeli LPatientMsgEventMsgChannel

Name

PatientMsgEventID

Code

PatientMsgEventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MsgChannelID tabeli LPatientMsgEventMsgChannel

Definicja kolumny MsgChannelID tabeli LPatientMsgEventMsgChannel

Name

MsgChannelID

Code

MsgChannelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ScheduleExpression tabeli LPatientMsgEventMsgChannel

Definicja kolumny ScheduleExpression tabeli LPatientMsgEventMsgChannel

Name

ScheduleExpression

Code

ScheduleExpression

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Synchronously tabeli LPatientMsgEventMsgChannel

Definicja kolumny Synchronously tabeli LPatientMsgEventMsgChannel

Name

Synchronously

Code

Synchronously

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna Active tabeli LPatientMsgEventMsgChannel

Definicja kolumny Active tabeli LPatientMsgEventMsgChannel

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UserGroupIDs tabeli LPatientMsgEventMsgChannel

Definicja kolumny UserGroupIDs tabeli LPatientMsgEventMsgChannel

Name

UserGroupIDs

Code

UserGroupIDs

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Lista id grup uzytkowników rozdzielona przecinkiem


Kolumna UserTypeIDs tabeli LPatientMsgEventMsgChannel

Definicja kolumny UserTypeIDs tabeli LPatientMsgEventMsgChannel

Name

UserTypeIDs

Code

UserTypeIDs

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Lista id typów uzytkowników rozdzielona przecinkiem


Kolumna PersonIDs tabeli LPatientMsgEventMsgChannel

Definicja kolumny PersonIDs tabeli LPatientMsgEventMsgChannel

Name

PersonIDs

Code

PersonIDs

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Lista id uzytkowników rozdzielona przecinkiem


Kolumna HeadOfWard tabeli LPatientMsgEventMsgChannel

Definicja kolumny HeadOfWard tabeli LPatientMsgEventMsgChannel

Name

HeadOfWard

Code

HeadOfWard

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy wiadomosc ma zostac wystala na ordynatora


Kolumna EventDoctor tabeli LPatientMsgEventMsgChannel

Definicja kolumny EventDoctor tabeli LPatientMsgEventMsgChannel

Name

EventDoctor

Code

EventDoctor

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy wiadomosc ma zostac wystala na lekarza prowadzacego


Kolumna TwoWayEnabled tabeli LPatientMsgEventMsgChannel

Definicja kolumny TwoWayEnabled tabeli LPatientMsgEventMsgChannel

Name

TwoWayEnabled

Code

TwoWayEnabled

Data Type

NUMBER(1)

Mandatory

Yes

Comment

czy dla wiadomosci (powiadomienie konkretnym kanalem) jest wlaczona komunikacja dwustronna


Lista kluczy tabeli LPatientMsgEventMsgChannel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPatientMsgEventMsgChannel

Definicja klucza Identifier_1 tabeli LPatientMsgEventMsgChannel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment